 gem 'ibm_db'  
 require 'mswin32/ibm_db'  
   
 def test conn  
     sql = "CALL GET_NAME(?)"  
     stmt = IBM_DB::prepare conn, sql  
     return_value = 0  
     IBM_DB::bind_param stmt, 1, "return_value"  
     IBM_DB::execute(stmt)  
     puts return_value  
       
           
     while (row = IBM_DB::fetch_array(stmt))  
         puts  " #{row[0]},-----,#{row[1]}"  
         end     
       
       
   end  
     
   conn = IBM_DB::connect 'webduke', 'web_dev2', 'ebiz02vs'  
     
   test conn  
     
   IBM_DB::close conn  
